/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : mybatis

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 07/09/2021 00:26:39
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS `account`;
CREATE TABLE `account` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `money` double DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of account
-- ----------------------------
BEGIN;
INSERT INTO `account` VALUES (1, 'jack', 8200);
INSERT INTO `account` VALUES (2, 'rose', 8000);
INSERT INTO `account` VALUES (3, 'tom', 8000);
COMMIT;

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ordertime` datetime DEFAULT NULL,
  `total` double DEFAULT NULL,
  `userid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of orders
-- ----------------------------
BEGIN;
INSERT INTO `orders` VALUES (1, '2019-11-01 19:26:19', 100, 1);
INSERT INTO `orders` VALUES (2, '2019-11-02 19:26:41', 590, 1);
INSERT INTO `orders` VALUES (3, '2019-07-10 19:26:51', 200, 2);
INSERT INTO `orders` VALUES (4, '2010-02-06 19:27:03', 1200, 3);
INSERT INTO `orders` VALUES (5, '2009-11-20 19:27:16', 268, 3);
INSERT INTO `orders` VALUES (6, '2055-07-06 19:27:29', 1890, 3);
INSERT INTO `orders` VALUES (7, '2020-07-06 19:27:43', 500, 4);
INSERT INTO `orders` VALUES (8, '2019-12-21 19:27:57', 5680, 4);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(100) DEFAULT NULL,
  `sex` varchar(1) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'Tom', '男', '北京');
INSERT INTO `user` VALUES (2, 'Cat', '女', '⻄安');
INSERT INTO `user` VALUES (3, 'Joy', '男', '香港');
INSERT INTO `user` VALUES (4, 'Jerry', '男', '⻄藏');
INSERT INTO `user` VALUES (5, '张三', '男', '深圳');
INSERT INTO `user` VALUES (6, '张三', '男', '深圳');
INSERT INTO `user` VALUES (7, '张三', '男', '深圳');
INSERT INTO `user` VALUES (8, '张三22', '男', '深圳');
COMMIT;

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键自增ID',
  `user_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名',
  `user_password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码',
  `description` varchar(1024) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述信息',
  `type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '用户类型,0-运营商,1-商户',
  `shop_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '商家ID',
  `delete_flag` tinyint(2) NOT NULL DEFAULT '0' COMMENT '删除标记',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_user_name` (`user_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of user_info
-- ----------------------------
BEGIN;
INSERT INTO `user_info` VALUES (15, '张三', '123456', 'xxx', 0, 0, 0, '2021-09-06 23:57:35', '2021-09-06 23:57:35');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
